﻿CREATE TABLE [dbo].[NKNH_L] (
    [ID]            BIGINT         IDENTITY (1, 1) NOT NULL,
    [NHID]          BIGINT         NOT NULL,
    [tk_sap]        NVARCHAR (255) NULL,
    [tk]            NVARCHAR (255) NULL,
    [chitiet_tksap] NVARCHAR (255) NULL,
    [chitiet_tk]    NVARCHAR (255) NULL,
    [so_tien]       FLOAT (53)     NULL,
    [ngoaite]       FLOAT (53)     NULL,
    [noi_dung]      NVARCHAR (255) NULL,
    [tenhhdv]       NVARCHAR (255) NULL,
    [ghichu]        NVARCHAR (255) NULL,
    [tle_vat]       FLOAT (53)     NULL,
    [tien_vat]      FLOAT (53)     NULL,
    [loai]          NVARCHAR (255) NULL,
    [nt_vat]        FLOAT (53)     NULL,
    [masothue]      NVARCHAR (255) NULL,
    [so_seri]       NVARCHAR (255) NULL,
    [tenkh]         NVARCHAR (255) NULL,
    [malctte]       NVARCHAR (255) NULL,
    [so_hdon]       NVARCHAR (255) NULL,
    CONSTRAINT [PK_NKNH_L] PRIMARY KEY CLUSTERED ([ID] ASC),
    CONSTRAINT [FK_NKNH_L_NKNH_H] FOREIGN KEY ([NHID]) REFERENCES [dbo].[NKNH_H] ([NHID])
);

